<?php

namespace AdminBundle\Repository;


class HuobiAlertSenderRepository extends BaseRepository
{
    /**
     * 随机获取一个发件人
     * @return bool
     * @throws \Exception
     */
    public function getSender()
    {
        $sql = <<<EOF
SELECT 
    name, email as addr, password
FROM
    cloud_control.huobi_alert_sender
WHERE
    `status` = 0
ORDER BY RAND() DESC
EOF;
        return $this->rawQuery($sql);
    }

}
